package edu.xjtu.jih.control;

import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserDao {

    @Select("select * from user")
    List<user> finduserList();

    @Select("count item_id from item where u_id = #{u_id}")
    int getUseritem(int u_id);

    @Select("select * from items")
    List<item> getItemList();

    @Select("delete from user where u_id = #{u_id}")
    void deleteU(user itemd);

    @Select("delete from items where item_id = #{item_id}")
    void deleteI(item itemd);
}
